Release 10.1A: OpenEdge Data Management:
SQL Reference

Data types syntax in BNF

Data Type

Syntax

data_type ::= char_data_type | exact_numeric_data_type | approx_numeric_data_type | date_time_data_type | bit_string_data_type

Character data type

Syntax

char_data_type ::= { CHARACTER | CHAR } [ ( length ) ] | { CHARACTER VARYING | CHAR VARYING | CLOB | VARCHAR } [ (length) ]

Exact numeric data type

Syntax

exact_numeric_data_type ::= TINYINT | SMALLINT | INTEGER | NUMERIC | NUMBER [ ( precision [ , scale ] ) ] | DECIMAL [ ( precision , scale ) ]

Approximate numeric data type

Syntax

approx_numeric_data_type ::= { REAL | DOUBLE PRECISION | FLOAT [ ( precision ) ] }

Date-time data type

Syntax

date_time_data_type :: DATE | TIME | TIMESTAMP | TIMESTAMP WITH TIME ZONE

Bit string data type

Syntax

bit_string_data_type ::= BIT | BINARY [ ( length ) ] | BLOB [ ( length ) ] | VARBINARY [( length ) ] | LONG VARBINARY [( length ) ]